# Excel Can embed excel workbooks like: ([how to](https://support.microsoft.com/en-us/office/share-it-embed-an-excel-workbook-on-your-web-page-or-blog-from-onedrive-804e1845-5662-487e-9b38-f96307144081#:~:text=Open%20the%20OneDrive%20website%2C%20and,then%20copy%20the%20iframe%20source.)) <iframe width="100%" height="460" frameborder="0" scrolling="no" src="https://onedrive.live.com/embed?resid=9E2DB906D2E7C980%2120629&authkey=%21AFNIywt-K7NpAog&em=2&wdAllowInteractivity=False&Item=Chart%201&wdInConfigurator=True&wdInConfigurator=True"></iframe> ## Parts ### Sparklines right click cell(s) to access Example: ![[Financial spending chart.png|200]] ## VBA #### Basics Continue code on next line ([source](https://stackoverflow.com/questions/22854386/how-to-continue-the-code-on-the-next-line-in-vba)) ``` this is some code _ use the underline to continue it ``` custom functions must be in a module #### API Requests >[!question] what does `As New MSXML2.XMLHTTP60` represent [Official documentation for xmlhttpRequest](https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms759148(v=vs.85)) "o use early-binding add reference to these libraries: `Microsoft XML` and `Microsoft WinHTTP services`:" [source](https://stackoverflow.com/questions/77320961/http-request-in-vba-using-winhttp-winhttprequest-5-1-basic-authentication-401-a) Examples/Tutorials: - [make http requests in excel vba by codingislove.com](https://codingislove.com/http-requests-excel-vba/) - [how to build a simple weather app](https://codingislove.com/weather-app-in-excel-vba/) - https://github.com/armineminasyan/vba-gmaps-directions ## Resources [Guide - W3 Schools](https://www.w3schools.com/excel/index.php) [Manually add a google geocoding custom function via vba](https://www.adventuresincre.com/auto-populate-latitude-longitude-excel/) - [full VBA code](https://www.adventuresincre.com/wp-content/uploads/2018/03/Latitude-Longitude-VBA-Code_v3.txt) - very nice layout https://www.reddit.com/r/vba/comments/rauslf/api_call_in_vba/ https://vbaplanet.com/libmsxml2.php - https://vbaplanet.com/http.php